Advanced Microsoft Excel

Course Contents:

The courses that are covered in this program include:

Using logical functions
Naming ranges
Creating named ranges
Using named ranges in formulas
The IF function (recap)
Creating nested IF functions
AND and OR functions
Combining logical functions
Working with lookups
The VLOOKUP function
The HLOOKUP function
Advanced list management
Using data validation
Setting criteria for entry of text, values and dates
Creating a dropdown list
Using database functions
Setting up criteria
DSUM
DAVERAGE
DCOUNT
Pivot Tables and Pivot Charts
Using the PivotTable Wizard
Rearranging PivotTables
Using the PivotTable toolbar
Creating Pivot Charts
Using Slicers to manipulate PivotTables
Using analytical options
Using Goal Seek
Using the Solver add-in
Working with scenarios
Creating and saving scenarios
Viewing scenarios
Macros 

" I love how they train,the tutor is friendly,he makes sure you understand what he is teaching.I am very grateful, GoldTech ICT HUB is the best Computer training institute ever.GoldTech ICT HUB you are the best!  "
Bakare Ajetumobi



"GoldTech ICT HUB is a great place to be because the staffs are very social,hospitable and down to earth and our teacher was a great person to be around because he tries as much as possible to explain to the least possible detail for easy understanding,He was very good "

Gbolahan Muktar



"The instructor was very focused and always ready to impact knowledge, GoldTech ICT HUB is a lovely place.  "

Adewale Gafar



"GoldTech ICT HUB is a good organisation with well cultured workers and a very clean environment. I am impressed with the certificate in digital literacy program, the teacher was nice, he was always ready to impact knowledge irrespective of any challenges.Thanks to all,It was a pleasure all through my days"

Rophyat Raheem



" The training was cool and we had a nice teacher who is always ready to for us, i loved the class and i am going to tell my friends at home to come for the training "

Busola Adekunle



" The training i underwent was very interesting and i learnt alot from the teachers/instructors because they made sure we understood everything we being taught,I will also want to use this opportunity to thank the staffs and everyone for their love and also for them to keep up the good work! "

Ibrahim Oyewole



" This training was very nice and conducive and i am so glad on how we were being treated in this training centre. More power to your elbows. "

Ifeoluwa Anuoluwapo



" Infact am so happy with this computer program, Why? because i can now operate computers and i can do alot in the office without any problems I give thanks to the management for their understanding and cooperation "

Linda Attai


" The training conducted on certificate in digital literacy was quite okay and well delivered courtesy of the qualified and dedicated instructors in the institute. Based on this i recommend it to all and sundry "

Segun Akerele



" It was awesome being in GoldTech ICT HUB, the tutor was competent, the students were friendly, the environment was convenient. In fact it was a wonderful experience. "

Azeez Oladunni



" The training was very comprehensive, impactful and friendly. I will return again for further training in other areas if time and resources permit. I am more than impressed. "

Busola Adedokun



"The teaching has been excellent and top class, the environment is conducive for learning and I don’t have any problems with the institution.” Keep it up "

Musa Kazeem



" GoldTech ICT HUB is a computer institute that helps students to really know what computer is all about with both theory and practical aspect. "

Mojeed Ajide



" The program was great one, it helped me to develop more skills about computer and how to be useful and friendly with the system. Thanks to those involved "

Ekene Menar




"Well, the training went smoothly without incident. The teaching was top class as usual and the environment was very accommodating and conducive for learning. I am happy that I came to study here, I have gained a lot, keep up the good work."

Endurance




"My time in GoldTech ICT HUB has been well spent from our instructors to the environment, everything was well coordinated"

Eniola Ige




"Honestly, it was a very good experience, I learnt a lot of things, concerning information technology, good instructor, conducive environment for learning"

Paul Emeka